Error: Cannot use AutoFormat due to no range selected or detected.

Error:

AutoFormat cannot detect a table around the active cell. Select the range to be formatted and choose the command again.

Cause:

This problem occurs because a single cell is selected and there are no tables around that cell. Usually, a cell range rather than a single cell needs to be selected for AutoFormat to work. If a range is not selected, the selected cell must be within an existing table.

Solution:

Select the range and select 'AutoFormat...' in the 'Format' menu again.